package com.techysky.repository;

import java.io.Serializable;

import org.springframework.data.jpa.repository.Query;

import com.techysky.entity.MaintRecord;

public interface MaintRecordRepository  extends CoreRepository<MaintRecord, Serializable>{
	@Query(value="select COUNT(*) from  sys_maint_record  t  where t.maint_date>=?1 and t.maint_date<=?2 and t.plan_id=?3", nativeQuery = true)
	int findMaintRecord(String endStDate, String systemTime, String string);
	

}
